Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RC_BACKUP_ARCHIVELOG_DETAILS

`RC_BACKUP_ARCHIVELOG_DETAILS` provides detailed information about backups of archived redo log files.

This view is primarily intended to be used internally by Enterprise Manager.

Column | Datatype | Description
--- | --- | ---
`BTYPE` | `CHAR(9)` | The backup type container, which can be `BACKUPSET`, `IMAGECOPY` or `PROXYCOPY`.
`BTYPE_KEY` | `NUMBER` | A unique identifier for the backup type. For backupsets, it is VS_KEY; for image copies, it is COPY_KEY; for proxy copies it is XAL_KEY.
`SESSION_KEY` | `NUMBER` | Unique identifier for this session.
`SESSION_RECID` | `NUMBER` | The RECID from the control file for the target database which corresponds to this RMAN session.
`SESSION_STAMP` | `NUMBER` | The STAMP from the control file for the target database which corresponds to this RMAN session.
`DB_KEY` | `NUMBER` | The primary key for this database in the recovery catalog. Use this column to form a join with almost any other catalog view.
`DB_NAME` | `VARCHAR2(8)` | The `DB_NAME` of the database incarnation to which this record belongs.
`ID1` | `NUMBER` | For archived logs in backup sets, this column contains SET_STAMP. For proxy copy or image copy backups, this column contains the RECID from the control file.
`ID2` | `NUMBER` | For archived logs in backup sets, this column contains SET_COUNT. For image copy or proxy copy backups, this column contains STAMP.
`THREAD#` | `NUMBER` | Thead number of this archived redo log file.
`SEQUENCE#` | `NUMBER` | Sequence number of this archived redo log file.
`RESETLOGS_CHANGE#` | `NUMBER` | SCN of OPEN RESETLOGS branch for this archived log.
`RESETLOGS_TIME` | `DATE` | Time of OPEN RESETLOGS branch for this archived log.
`FIRST_CHANGE#` | `NUMBER` | Starting SCN for this archived log file.
`FIRST_TIME` | `DATE` | Time corresponding to starting SCN for this archived redo log file.
`NEXT_CHANGE#` | `NUMBER` | Ending SCN for this archived redo log file.
`NEXT_TIME` | `DATE` | Time corresponding to the ending SCN for this archived redo log file.
`FILESIZE` | `NUMBER` | Size of backed up redo log file, in bytes.
`COMPRESSION_RATIO` | `NUMBER` | Compression ratio for this backup.
`FILESIZE_DISPLAY` | `VARCHAR2(4000)` | Same value as `FILESIZE`, but converted to a user-displayable format, for example nM, nG, nT, nP.